using SqlSugar;

namespace CoreShop.Model
{
    /// <summary>
    /// 用户绑定优惠卷表
    /// </summary>
    public class corecmsfoodcouponuser
    {
        /// <summary>
        /// 构造函数
        /// </summary>
        public corecmsfoodcouponuser()
        {
        }

        /// <summary>
        /// 序号
        /// </summary>
        [SugarColumn(ColumnDescription = "序号", IsPrimaryKey = true)]
        public System.Int64 id { get; set; }

        /// <summary>
        /// 总店Id
        /// </summary>
        [SugarColumn(ColumnDescription = "总店Id")]
        public System.Int32 corpId { get; set; }


        /// <summary>
        /// 门店id
        /// </summary>
        [SugarColumn(ColumnDescription = "门店id")]
        public System.Int32 storeId { get; set; }


        /// <summary>
        /// 绑定会员Id
        /// </summary>
        [SugarColumn(ColumnDescription = "绑定会员Id",IsNullable =true)]
        public System.Int64 userId { get; set; }


        /// <summary>
        /// 优惠卷Id
        /// </summary>
        [SugarColumn(ColumnDescription = "优惠卷Id")]
        public System.Int64 couponId { get; set; }


        /// <summary>
        /// 新增时间
        /// </summary>
        [SugarColumn(ColumnDescription = "发放时间", SerializeDateTimeFormat = "YYYY-MM-DD", IsNullable = true)]
        public System.DateTime createTime { get; set; }


        /// <summary>
        /// 使用状态使用状态（1已发放，2已使用，3已停用）
        /// </summary>
        [SugarColumn(ColumnDescription = "使用状态")]
        public System.Int32 status { get; set; }


        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(Length =50, ColumnDescription = "备注", IsNullable = true)]
        public System.String remark { get; set; }

        /// <summary>
        /// 微信用户id
        /// </summary>
        [SugarColumn(ColumnDescription = "微信用户id", IsNullable = true)]
        public System.Int32 userWxId { get; set; }

        /// <summary>
        /// 优惠券码
        /// </summary>
        [SugarColumn(ColumnDescription = "优惠券码",Length =20)]
        public System.String couponCode { get; set; }

        /// <summary>
        /// 创建人id
        /// </summary>
        [SugarColumn(ColumnDescription = "创建人id")]
        public System.Int32 createUserId { get; set; }

        /// <summary>
        /// 使用时间
        /// </summary>
        [SugarColumn(ColumnDescription = "使用时间",IsNullable =true)]
        public System.DateTime? useTime { get; set; }

        /// <summary>
        /// 使用密码
        /// </summary>
        [SugarColumn(Length =16, ColumnDescription = "使用密码", IsNullable = true)]
        public System.String password { get; set; }

        /// <summary>
        /// 发放时间
        /// </summary>
        [SugarColumn(ColumnDescription = "发放时间", SerializeDateTimeFormat ="YYYY-MM-DD", IsNullable =true)]
        public System.DateTime? distributionDate { get; set; }

        /// <summary>
        /// 领取时间
        /// </summary>
        [SugarColumn(ColumnDescription = "领取时间", SerializeDateTimeFormat = "YYYY-MM-DD", IsNullable = true)]
        public System.DateTime? collectionTime { get; set; }

        /// <summary>
        /// 开始领取时间
        /// </summary>
        [SugarColumn(ColumnDescription = "开始领取时间", SerializeDateTimeFormat = "yyyy-MM-dd", IsNullable = true)]
        public System.DateTime? collectionStartDate { get; set; }

        /// <summary>
        /// 结束领取时间
        /// </summary>
        [SugarColumn(ColumnDescription = "结束领取时间", SerializeDateTimeFormat = "yyyy-MM-dd", IsNullable = true)]
        public System.DateTime? collectionEndDate { get; set; }

        /// <summary>
        /// 使用状态使用状态（0未使用，1已使用，2已过期）
        /// </summary>
        [SugarColumn(ColumnDescription = "优惠券名称", IsIgnore = true)]
        public System.String couponName { get; set; }

        /// <summary>
        /// 优惠券类型 （1.代金券 ;2.商品兑换券;3.折扣券)
        /// </summary>
        [SugarColumn(ColumnDescription = "优惠券类型 （1.代金券 ;2.商品兑换券;3.折扣券)", IsIgnore = true)]
        public System.Int32? typeId { get; set; }


        /// <summary>
        /// 卷面值
        /// </summary>
        [SugarColumn(ColumnDescription = "卷面值", IsIgnore = true)]
        public System.Decimal? parValue { get; set; }


        /// <summary>
        /// 使用有效期类型(0.自定义日期；1.相对有效期)
        /// </summary>
        [SugarColumn(ColumnDescription = "使用有效期类型(0.自定义日期；1.相对有效期)", IsIgnore = true)]
        public System.Int32? validityType { get; set; }


        /// <summary>
        /// 优惠券开始有效期
        /// </summary>
        [SugarColumn(ColumnDescription = "优惠券开始有效期", IsIgnore = true)]
        public System.DateTime? startDate { get; set; }


        /// <summary>
        /// 优惠券结束有效期
        /// </summary>
        [SugarColumn(ColumnDescription = "优惠券结束有效期", IsIgnore = true)]
        public System.DateTime? endDate { get; set; }

 
        [SugarColumn(ColumnDescription = "会员名称", IsIgnore = true)]
        public System.String userName { get; set; }

        [SugarColumn(ColumnDescription = "会员卡号", IsIgnore = true)]
        public System.String number { get; set; }

        [SugarColumn(ColumnDescription = "有效天数", IsIgnore = true)]
        public System.Int32? validDay { get; set; }

        [SugarColumn(ColumnDescription = "分类名称", IsIgnore = true)]
        public System.String typeName { get; set; }

        [SugarColumn(ColumnDescription = "优惠券说明", IsIgnore = true)]
        public System.String description { get; set; }

    }
}
